Problem Note 47878: Running the SAS_SCORE_EP stored procedure might result in Teradata execute errors and cause SAS® Scoring Accelerator for Teradata to fail
Running the SAS_SCORE_EP stored procedure might result in an error. The problem occurs when the model used in the %INDTD_PUBLISH_MODEL macro contains a large number of input variables. An error similar to one of the following might occur:
ERROR: Teradata execute: in UDF/XSP/UDM SAS_SYSFNLIB.sas_score_ep: SQLSTATE
U0028: Prepare INQUERY
failed: Error Code 3822: Cannot resolve column 'id'. Specify table or view.
Or:
ERROR: Teradata execute: in UDF/XSP/UDM SAS_SYSFNLIB.sas_score_ep: SQLSTATE
U0052: INQUERY must be a valid SELECT statement.
There is no workaround other than to reduce the number of input variables when publishing the model.
Operating System and Release Information
| SAS System | SAS Scoring Accelerator for Teradata | Teradata on Linux | 9.3 TS1M0 | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-10-06 12:57:09 |
| Date Created: | 2012-09-13 10:43:59 |
